﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;

public partial class CustomerManagement_MarginManagementDetail : System.Web.UI.Page
{
    TextBox txtNote;
    private string Code
    {
        get
        {
            return Request.QueryString["code"] != null ? Request.QueryString["code"].ToString() : "";
        }
    }
    private DataSet DstDetails
    {
        get
        {
            DataSet dstDetails = null;
            if (ViewState["DstDetails"] != null)
            {
                dstDetails = (DataSet)ViewState["DstDetails"];
            }
            return dstDetails;
        }
        set
        {
            ViewState["DstDetails"] = value;
        }
    }
    private bool IsAudit
    {
        get
        {
            bool isAudit = false;
            if (ViewState["IsAudit"] != null)
            {
                isAudit = Convert.ToBoolean(ViewState["IsAudit"]);
            }
            return isAudit;
        }
        set
        {
            ViewState["IsAudit"] = value;
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        Check.CheckPermission("300400109");
        if (!IsPostBack)
        {
            BindMain();
            BindDetails();
            if (this.IsAudit)
            {
                btnAudit.Enabled = false;
                btnDelete.Enabled = false;
                btnSave.Enabled = false;
                btnCancel.Enabled = false;
                btnAddDetail.Enabled = false;
            }
        }

        Session["FCode"] = "300400109";
    }

    private void BindMain()
    {

        DataSet dst = new BLL.MarginAdjust().GetMainById(this.Code);
        if (dst.Tables[0].Rows.Count > 0)
        {
            this.IsAudit = dst.Tables[0].Rows[0]["MA_CHECK"].ToString() == "1" ? true : false;
        }
        dlistMain.DataSource = dst;
        dlistMain.DataBind();

        if (this.IsAudit)
        {
            dlistMain.Enabled = false;
        }
    }
    private void BindDetails()
    {
        this.DstDetails = new BLL.MarginAdjustDetail().GetDetailsById(this.Code);
        dlistDetail.DataSource = this.DstDetails;
        dlistDetail.DataBind();
        if (this.IsAudit)
        {
            dlistDetail.Enabled = false;
        }
    }

    private void SetValueOfDataTable(DataSet dst)
    {
        Label lblDetailId;
        Label lblCustomerCode;
        Label lblCustomerName;
        Label lblCTName;
        TextBox txtAmount;
        TextBox txtNote;

        for (int i = 0; i < dlistDetail.Items.Count; i++)
        {
            lblDetailId = (Label)dlistDetail.Items[i].FindControl("lblDetailId");
            lblCustomerCode = (Label)dlistDetail.Items[i].FindControl("lblCustomerCode");
            lblCustomerName = (Label)dlistDetail.Items[i].FindControl("lblCustomerName");
            lblCTName = (Label)dlistDetail.Items[i].FindControl("lblCTName");
            txtAmount = (TextBox)dlistDetail.Items[i].FindControl("txtAmount");
            txtNote = (TextBox)dlistDetail.Items[i].FindControl("txtNote");

            dst.Tables[0].Rows[i]["MAD_ID"] = lblDetailId.Text;
            dst.Tables[0].Rows[i]["MAD_CustomerID"] = lblCustomerCode.Text;
            dst.Tables[0].Rows[i]["GKMC"] = lblCustomerName.Text;
            dst.Tables[0].Rows[i]["CT_NAME"] = lblCTName.Text;
            dst.Tables[0].Rows[i]["MAD_AMT"] = Convert.ToDecimal(txtAmount.Text.Trim());
            dst.Tables[0].Rows[i]["MAD_Note"] = txtNote.Text.Trim();
        }

    }

    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (!Check.CheckPermission("300400109", "00017"))
        {
            Share.Alert(this.Page, "无权操作"); return;
        }
        try
        {
            Model.MarginAdjust ma = new BLL.MarginAdjust().GetModel(this.Code);
            if (ma != null)
            {
                if (ma.MA_Check==1)
                {
                    throw new Exception("此单据已被审核，不允许再次操作！");
                }
            }
            SetValueOfDataTable(this.DstDetails);
            if (this.DstDetails.Tables[0].Rows.Count == 0)
            {
                throw new Exception("请选择您要调整的会员！");
            }
            if (new BLL.MarginAdjust().Save(this.Code, this.DstDetails, ((TextBox)dlistMain.Items[0].FindControl("txtNote")).Text))
            {
                Share.InsertLog("300400109", "00017");
                Share.Alert(this.Page, "保存成功！");
            }
            else
            {
                Share.Alert(this.Page, "保存失败，请重新尝试保存！");
            }

        }
        catch (Exception ex)
        {
            Share.Alert(this.Page, ex.Message);
        }
    }

    protected void btnAudit_Click(object sender, EventArgs e)
    {
        if (!Check.CheckPermission("300400109", "00010"))
        {
            Share.Alert(this.Page, "无权操作"); return;
        }
        try
        {
            Model.MarginAdjust ma = new BLL.MarginAdjust().GetModel(this.Code);
            if (ma != null)
            {
                if (ma.MA_Check == 1)
                {
                    throw new Exception("此单据已被审核，不允许再次操作！");
                }
            }

            DataSet dstDetails = new BLL.MarginAdjustDetail().GetDetails(this.Code);
            StringBuilder strSqlToUpdateBStyleDB = new StringBuilder();
            char[] charToTrim = new char[] { '|' };
            string user = Share.UserValue(0);

            for (int i = 0; i < dlistMain.Items.Count; i++)
            {
                txtNote = (TextBox)dlistMain.Items[i].FindControl("txtNote");
            }

            strSqlToUpdateBStyleDB.Append("update MarginAdjust set MA_Check=1,MA_Checker='");
            strSqlToUpdateBStyleDB.Append(user);
            strSqlToUpdateBStyleDB.Append("',MA_CheckDate='");
            strSqlToUpdateBStyleDB.Append(DateTime.Now);
            strSqlToUpdateBStyleDB.Append("',MA_Note='");
            strSqlToUpdateBStyleDB.Append(txtNote.Text.Trim());
            strSqlToUpdateBStyleDB.Append("' where MA_ID='");
            strSqlToUpdateBStyleDB.Append(this.Code);
            strSqlToUpdateBStyleDB.Append("'|");

            for (int i = 0; i < dstDetails.Tables[0].Rows.Count; i++)
            {
                strSqlToUpdateBStyleDB.Append("update V_CUSTOMER_AUTO set BYZD8=isnull(BYZD8,0)+");
                strSqlToUpdateBStyleDB.Append(dstDetails.Tables[0].Rows[i]["MAD_AMT"].ToString());
                strSqlToUpdateBStyleDB.Append(" where vc_code='");
                strSqlToUpdateBStyleDB.Append(dstDetails.Tables[0].Rows[i]["MAD_CustomerID"].ToString());
                strSqlToUpdateBStyleDB.Append("'|");
            }

            string stringSql = strSqlToUpdateBStyleDB.ToString();
            string[] sqlCommandArray = stringSql.TrimEnd(charToTrim).Split(charToTrim);

            if (new SQLServerDAL.ORDERDOC().Deliver(sqlCommandArray))
            {
                btnAudit.Enabled = false;
                btnDelete.Enabled = false;
                btnSave.Enabled = false;
                btnCancel.Enabled = false;
                btnAddDetail.Enabled = false;
                BindMain();
                BindDetails();

                Share.InsertLog("300400109", "00010");
                Share.Alert(this.Page, "审核成功！");
            }
            else
            {
                Share.Alert(this.Page, "审核失败，请重新审核！");
            }
        }
        catch (Exception ex)
        {
            Share.Alert(this.Page, ex.Message);
        }
    
    }

    protected void btnDelete_Click(object sender, EventArgs e)
    {
        if (!Check.CheckPermission("300400109", "00003"))
        {
            Share.Alert(this.Page, "无权操作"); return;
        }
        try
        {
            Model.MarginAdjust ma = new BLL.MarginAdjust().GetModel(this.Code);
            if (ma != null)
            {
                if (ma.MA_Check == 1)
                {
                    throw new Exception("此单据已被审核，不允许再次操作！");
                }
            }
            bool result = new BLL.MarginAdjust().Delete(Code);
            if (result)
            {
                Share.InsertLog("300400109", "00003");
                Response.Write("<script>alert('删除成功！');window.location.href='MarginManagement.aspx'</script>");
            }
            else
            {
                Response.Write("<script>alert('删除失败！');</script>");
            }
        }
        catch (Exception ex)
        {
            Share.Alert(this.Page, ex.Message);
        }
    }

    protected void btnCancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("MarginManagementDetail.aspx?code=" + this.Code);
    }

    protected void btnReturn_Click(object sender, EventArgs e)
    {
        Response.Redirect("MarginManagement.aspx");
    }

    protected void btnAddDetail_Click(object sender, EventArgs e)
    {
        try
        {
            // BindType();
            string customerCode = hidUserCode.Value;
            if (customerCode != "")
            {
                string[] customersArray = customerCode.Split('|');
                if (customersArray.Length > 0)
                {
                    string[] customer;
                    for (int i = 0; i < customersArray.Length; i++)
                    {
                        customer = customersArray[i].Split(' ');
                        string ctname="";
                        DataSet ds = new BLL.MarginAdjustDetail().GetCustomerTypeByCustomerId(customer[0]);
                        if (ds.Tables[0].Rows.Count > 0)
                        {
                            ctname=ds.Tables[0].Rows[0]["CT_NAME"].ToString();
                        }
                        if(customer.Length == 2)
                        {
                            SetValueOfDataTable(this.DstDetails);
                            this.DstDetails = new BLL.MarginAdjustDetail().AddDataRowToDataTable(this.DstDetails, Convert.ToString(this.DstDetails.Tables[0].Rows.Count + 1), customer[0], customer[1], ctname);
                            dlistDetail.DataSource = this.DstDetails;
                            dlistDetail.DataBind();
                        }
                    }
                }
            }
            else
            {
                Share.Alert(this.Page, "请选择会员！");
            }
            hidUserCode.Value = "";
        }
        catch (Exception ex)
        {
            Share.Alert(this.Page, ex.Message);
        }
    }
    
    protected void dlistDetail_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName.ToLower() == "del")
        {
            if (dlistDetail != null)
            {

                this.DstDetails.Tables[0].Rows.RemoveAt(e.Item.ItemIndex);
                dlistDetail.DataSource = this.DstDetails;
                dlistDetail.DataBind();

            }

        }
    }
    
}
